Basic SQLite query statements
sqlite> pragma database_list; +---+------+------------------------------------------+ | 0 | main | /Users/siuha/Desktop/sqlite_table.sqlite | +---+------+------------------------------------------+ 1 rows in set (0.01 sec) sqlite> select Description, Cost from parts where PartNo = 2619; +--------------------+-------+ | Description | Cost | +--------------------+-------+ | Navigation Compass | 9.177 | +--------------------+-------+ 1 rows in set (0.01 sec) sqlite>